NumericFunctions.Extract expression

Use the EXTRACT function to return a date/time field from a datetime or interval.

Format

ANSI-SQL Format:

EXTRACT ( { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND } FROM expression )

ODBC Format:

{{ FN EXTRACT ( { YEAR | MONTH | DAY | HOUR | MINUTE | SECOND } FROM expression ) }}

Remarks

The returned value is a numeric value that reflects the value of the field that is being extracted.